<?php

class CommentsFixture {
	
	public $tableName = 'comments';
	
	public $createSql = "CREATE  TABLE IF NOT EXISTS `comments` (
	  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
	  `user_id` INT UNSIGNED NOT NULL ,
	  `article_id` INT UNSIGNED NOT NULL ,
	  `comment` TEXT NOT NULL ,
	  `created_date` DATETIME NOT NULL ,
	  `updated_date` DATETIME NOT NULL ,
	  PRIMARY KEY (`id`)
	ENGINE = InnoDB";
	
	public $data = array(
		array(
			'id'			=>	1,
			'article_id'	=>	1,
			'user_id'		=>	1,
			'comment'		=>	'This is test comment 1.',
			'created_date'	=>	'2010-01-01 12:01:01',
			'updated_date'	=>	'2010-01-01 12:01:01',
		),
		array(
			'id'			=>	2,
			'article_id'	=>	1,
			'user_id'		=>	3,
			'comment'		=>	'This is test comment 2.',
			'created_date'	=>	'2010-03-01 12:01:01',
			'updated_date'	=>	'2010-03-01 12:01:01',
		),
		array(
			'id'			=>	3,
			'article_id'	=>	2,
			'user_id'		=>	1,
			'comment'		=>	'This is test comment 3.',
			'created_date'	=>	'2010-03-01 12:01:01',
			'updated_date'	=>	'2010-03-01 12:01:01',
		),
		array(
			'id'			=>	4,
			'article_id'	=>	4,
			'user_id'		=>	3,
			'comment'		=>	'This is test comment 4.',
			'created_date'	=>	'2010-03-01 12:01:01',
			'updated_date'	=>	'2010-03-01 12:01:01',
		),
	);
	
}